Experience in running relational databases on clustered storage
نویسندگان
چکیده
For past eight years, CERN IT Database group has based its backend storage on NAS (Network-Attached Storage) architecture, providing database access via NFS (Network File System) protocol. In last two and half years, our storage has evolved from a scale-up architecture to a scale-out one. This paper describes our setup and a set of functionalities providing key features to other services like Database on Demand [1] or CERN Oracle backup and recovery service. It also outlines possible trend of evolution that, storage for databases could follow.
منابع مشابه
A Semi-Structured Data Cartridge for Relational Databases
In this paper, we present our experiences on managing semi-structured data in relational databases. We use a Java package built on top of relational database for store and query semi-structured data. In this work, we introduced a more complete data model, a flexible storage scheme, and a compact metedata structure for processing regular path expressions.
متن کاملMain Memory Databases vs. Disk-Resident Databases
Storing all database data in memory is an idea that many researchers have been studying it from mid-1980s when RAM prices decreased while their capacity increased. Main Memory Database systems (MMDB) are an efficient solution to store all database data in main physical memory. Conventional database systems like relational databases are optimized for disk I/O operations but Memory resident datab...
متن کاملJoin Execution Using Fragmented Columnar Indices on GPU and MIC
The paper describes an approach to the parallel natural join execution on computing clusters with GPU and MIC Coprocessors. This approach is based on a decomposition of natural join relational operator using the column indices and domain-interval fragmentation. This decomposition admits parallel executing the resource-intensive relational operators without data transfers. All column index fragm...
متن کاملTowards Selection of Optimal Storage Architecture for Relational Databases
Requirements for database systems differ from small-scale stripped minimal database programs for embedded devices with minimal footprint to large-scale on-line analytical processing applications. For relational database management systems, two storage architectures have been introduced: a) row-oriented architecture and b) column-oriented architecture. In this paper, we present a query decomposi...
متن کاملThe Usasge and Performance of Object Databases Compared with ORM Tools in a Java Environment
Object databases have been almost entirely forgotten in the mainstream software development world. The huge interest in object databases during the 1990’s has changed to ignorance even though objectoriented programming languages like Java and C# continue to thrive. During the last couple of years many object-relational mapping tools have emerged to solve the notorious object-relational impedanc...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015